Syntax:
LastDateOfWeek(dateexpr, NumZ{day})
Description:
Returns the date of the last instance of the specified day in the week
of the date specified.
Parameter Description
dateexpr A the date to be used when determining the last instance of the day in the week.
NumZ{day} The day to check for.
ò vbSunday (1) - Sunday
ò vbMonday (2) - Monday
ò vbTuesday (3) - Tuesday
ò vbWednesday (4) - Wednesday
ò vbThursday (5) - Thursday
ò vbFriday (6) - Friday
ò vbSaturday (7) - Saturday
Example:
Sub
Main
'return the date of the last Sunday of this week.
lastSundayofthisweek = LastDateOfWeek(Now(),1)
'return the date of the last Friday of this
week.
lastMondayofthisweek = LastDateOfWeek(Now(),6)
See Also